echo "create database 'test'"
mysql -uroot -p --connect-expired-password -e "CREATE DATABASE test"
echo "create user 'yanzy'"
mysql -uroot -p --connect-expired-password -e "create user 'root'@'%' identified by 'root'"
echo 'give the privileges'
mysql -uroot -p --connect-expired-password -e "GRANT ALL PRIVILEGES ON test.* TO 'root'@'%'"
echo "done"

